Data Build Task

• Un-normalized data with repeated groups was analyzed.
• Data was converted to First Normal Form (1NF) by removing repeating groups and ensuring atomicity.
• Data was further separated into Second (2NF) and Third Normal Form (3NF) by splitting into Students, Courses, and ExamResults tables to remove partial and transitive dependencies.
• Primary keys assigned: student_number (Students), course_name (Courses), (student_number, course_name) (ExamResults).
• Foreign keys established in ExamResults to enforce referential integrity with Students and Courses.
• Database tested: foreign key violations prevented invalid inserts/deletes, confirming referential integrity.